USE HumanResources
GO
CREATE TABLE hr.RowCounts
(
   LogID INT PRIMARY KEY IDENTITY,
   ExecGUID UNIQUEIDENTIFIER NOT NULL,
   PackageName NVARCHAR(100) NOT NULL,
   SourceName NVARCHAR(100) NOT NULL,
   DestinationName NVARCHAR(100) NOT NULL,
   NumberRows INT NOT NULL,
   LogDateTime DATETIME NOT NULL DEFAULT(GETDATE())
);
GO
